<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table width="100%" height="100%" border="2">
  <tr>
    <td width="22%" height="95"><img src="logo.png" width="163" height="154" alt="Logo" /></td>
    <td width="78%"><h1>Island Auctions</h1>
    <p> Turning Junk Into Money</p></td>
  </tr>
  <tr>
    <td valign="top"><p><a href="index.jsp">Home</a></p>
    <p><a href="Browse.jsp">Browse</a></p>
    <p><a href="Search.jsp">Search</a></p>
    <p><a href="profile.jsp">Profile</a></p>
    <p><a href="Users.jsp">Users</a></p>
    <%
    try{
	    if(session.getValue("login") != null)
	    {%>
	    	<p><a href="Logout.jsp">Logout</a></p>
	    <%}
	    else
	    {%>
	    	<p><a href="login.jsp">Login</a></p>
	    <%}
    }catch(java.lang.IllegalStateException e)
    {%>
		<p><a href="login.jsp">Login</a></p><%
}%>

<%
try{
    if(session.getValue("empLevel") == "1")
    {%>
    	<p><a href="ManageEmployees.jsp">(Manage Employees)</a></p></td>
    <%}
    else
    {%>
    <br>
    <%}
}catch(java.lang.IllegalStateException e)
{%>
<br>
<%}
    %>
    <td valign="top">
    <%
    try{
    	if((session.getValue("login") == null) || (session.getValue("empLevel") == "-1"))
    	{
			response.sendRedirect("index.jsp");
    	}
    }catch(java.lang.IllegalStateException e)
    {
    	response.sendRedirect("index.jsp");
    }
    %>
    	
    <p><a href="createEmployee.jsp">Create Employees</a></p>
    <p><a href="SalesReport.jsp">Sales Report</a></p>
    <p><a href="ListItems.jsp">List All Items</a></p>
    <p><a href="ListSalesItemName.jsp">List Sales By..</a></p>
    <p><a href="ListByName.jsp">Revenue By Item Name</a></p>
    <p><a href="RepRevenue.jsp">Highest Employee Revenue</a></p>
    <p><a href="CustomerRevenue.jsp">Highest Customer Revenue</a></p>
    <p><a href="BestSeller.jsp">Best Sellers</a></p>
    <p><a href="EmailList.jsp">Email List</a></p>
    <p><a href="BackupDB.jsp">Backup DB</a></p>
    
    
    <h2>Employee List</h2>
    <%
	String mysJDBCDriver = "com.mysql.jdbc.Driver"; 
	String mysURL = "jdbc:mysql://mysql2.cs.stonybrook.edu:3306/jedale"; 
 	String mysUserID = "jedale"; 
	String mysPassword = "107200855";
	java.sql.Connection conn=null;
	try 
	{
       	Class.forName(mysJDBCDriver).newInstance();
			java.util.Properties sysprops=System.getProperties();
			sysprops.put("user",mysUserID);
			sysprops.put("password",mysPassword);
   
		//connect to the database
       			conn=java.sql.DriverManager.getConnection(mysURL,sysprops);
       			System.out.println("Connected successfully to database using JConnect");
       
     	java.sql.Statement stmt1=conn.createStatement();
    			java.sql.ResultSet rs = stmt1.executeQuery("Select Person.UserName From Employee, Person	Where EmployeeID = Person.SSN ORDER BY Person.UserName ASC");
			%>
			                    <table border="8" id="TABLE1" onclick="return TABLE1_onclick()">
			                    <tr>
			                      <td style="width: 84px">
			                          <span style="font-size: 10pt">
			                          User Name</span></td>
			                    </tr>   
			<%
			     	       	  
			      	  while(rs.next())
			        	{
			%>
			                    <tr>
			                      <td style="width: 84px">
			                          <span style="font-size: 10pt"><a href="profile.jsp?UserName=<%=rs.getString(1)%>"><%=rs.getString(1)%></a></span></td>                		
			                    </tr>
			<%      		
			        	}
	} catch(Exception e)
	{
		e.printStackTrace();
		out.print(e.toString());
	}
	finally{
	
		try{conn.close();}catch(Exception ee){};
	}	
		
    %>
    </td>
  </tr>
</table>
</body>
</html>